{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}/Users/sebastiantonke/Desktop/Replication Package/Replication files experiment/output_logs/table A10.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}12 Jul 2023, 02:11:51
{txt}
{com}. 
. 
. 
. estpost tabstat payment paymentcond invoices prepaidcounttotal preclosingbalance preage_of_account if t<=12, by(itt) statistics(mean p25 med p75 sd count) columns(statistics) nototal

{txt}Summary statistics: mean p25 p50 p75 sd count
     for variables: payment paymentcond invoices prepaidcounttotal preclosingbalance preage_of_account
  by categories of: itt

{space 0}{space 0}{ralign 12:itt}{space 1}{c |}{space 1}{ralign 9:e(mean)}{space 1}{space 1}{ralign 9:e(p25)}{space 1}{space 1}{ralign 9:e(p50)}{space 1}{space 1}{ralign 9:e(p75)}{space 1}{space 1}{ralign 9:e(sd)}{space 1}{space 1}{ralign 9:e(count)}{space 1}
{space 0}{hline 13}{c   +}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}
{space 0}{res:{lalign 13:0}}{c |}{space 11}{space 11}{space 11}{space 11}{space 11}{space 11}
{space 0}{space 0}{ralign 12:payment}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 109.0334}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:      100}}}{space 1}{space 1}{ralign 9:{res:{sf: 342.8336}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:paymentcond}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 305.1962}}}{space 1}{space 1}{ralign 9:{res:{sf:       81}}}{space 1}{space 1}{ralign 9:{res:{sf:      158}}}{space 1}{space 1}{ralign 9:{res:{sf:      315}}}{space 1}{space 1}{ralign 9:{res:{sf: 518.7835}}}{space 1}{space 1}{ralign 9:{res:{sf:    13002}}}{space 1}
{space 0}{space 0}{ralign 12:invoices}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 134.4327}}}{space 1}{space 1}{ralign 9:{res:{sf:     21.2}}}{space 1}{space 1}{ralign 9:{res:{sf:     53.7}}}{space 1}{space 1}{ralign 9:{res:{sf:    119.4}}}{space 1}{space 1}{ralign 9:{res:{sf: 361.0419}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:prepaidcou~l}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 4.149145}}}{space 1}{space 1}{ralign 9:{res:{sf:        2}}}{space 1}{space 1}{ralign 9:{res:{sf:        4}}}{space 1}{space 1}{ralign 9:{res:{sf:        6}}}{space 1}{space 1}{ralign 9:{res:{sf: 2.754684}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:preclosing~e}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 543.5434}}}{space 1}{space 1}{ralign 9:{res:{sf:    31.95}}}{space 1}{space 1}{ralign 9:{res:{sf:   138.55}}}{space 1}{space 1}{ralign 9:{res:{sf:   456.67}}}{space 1}{space 1}{ralign 9:{res:{sf: 2193.543}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{space 0}{ralign 12:preage_of_~t}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 44.30434}}}{space 1}{space 1}{ralign 9:{res:{sf:       19}}}{space 1}{space 1}{ralign 9:{res:{sf:       34}}}{space 1}{space 1}{ralign 9:{res:{sf:       53}}}{space 1}{space 1}{ralign 9:{res:{sf: 39.24582}}}{space 1}{space 1}{ralign 9:{res:{sf:    36394}}}{space 1}
{space 0}{hline 13}{c   +}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}
{space 0}{res:{lalign 13:1}}{c |}{space 11}{space 11}{space 11}{space 11}{space 11}{space 11}
{space 0}{space 0}{ralign 12:payment}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 110.7534}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:      100}}}{space 1}{space 1}{ralign 9:{res:{sf: 355.2334}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:paymentcond}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 308.9127}}}{space 1}{space 1}{ralign 9:{res:{sf:       85}}}{space 1}{space 1}{ralign 9:{res:{sf:      156}}}{space 1}{space 1}{ralign 9:{res:{sf:      301}}}{space 1}{space 1}{ralign 9:{res:{sf: 539.2301}}}{space 1}{space 1}{ralign 9:{res:{sf:    13178}}}{space 1}
{space 0}{space 0}{ralign 12:invoices}{space 1}{c |}{space 1}{ralign 9:{res:{sf:  132.221}}}{space 1}{space 1}{ralign 9:{res:{sf:     26.7}}}{space 1}{space 1}{ralign 9:{res:{sf:     53.7}}}{space 1}{space 1}{ralign 9:{res:{sf:    115.7}}}{space 1}{space 1}{ralign 9:{res:{sf: 319.6063}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:prepaidcou~l}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 4.177141}}}{space 1}{space 1}{ralign 9:{res:{sf:        2}}}{space 1}{space 1}{ralign 9:{res:{sf:        4}}}{space 1}{space 1}{ralign 9:{res:{sf:        6}}}{space 1}{space 1}{ralign 9:{res:{sf: 2.688395}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:preclosing~e}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 483.5314}}}{space 1}{space 1}{ralign 9:{res:{sf:    37.27}}}{space 1}{space 1}{ralign 9:{res:{sf:   125.61}}}{space 1}{space 1}{ralign 9:{res:{sf:   406.75}}}{space 1}{space 1}{ralign 9:{res:{sf: 1556.179}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{space 0}{ralign 12:preage_of_~t}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 45.37656}}}{space 1}{space 1}{ralign 9:{res:{sf:       19}}}{space 1}{space 1}{ralign 9:{res:{sf:       34}}}{space 1}{space 1}{ralign 9:{res:{sf:       55}}}{space 1}{space 1}{ralign 9:{res:{sf: 39.73673}}}{space 1}{space 1}{ralign 9:{res:{sf:    36756}}}{space 1}
{space 0}{hline 13}{c   +}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}{hline 11}
{space 0}{res:{lalign 13:2}}{c |}{space 11}{space 11}{space 11}{space 11}{space 11}{space 11}
{space 0}{space 0}{ralign 12:payment}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 108.3695}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:        0}}}{space 1}{space 1}{ralign 9:{res:{sf:      100}}}{space 1}{space 1}{ralign 9:{res:{sf: 325.1145}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:paymentcond}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 303.4042}}}{space 1}{space 1}{ralign 9:{res:{sf:       80}}}{space 1}{space 1}{ralign 9:{res:{sf:    155.5}}}{space 1}{space 1}{ralign 9:{res:{sf:      300}}}{space 1}{space 1}{ralign 9:{res:{sf: 486.5848}}}{space 1}{space 1}{ralign 9:{res:{sf:    12892}}}{space 1}
{space 0}{space 0}{ralign 12:invoices}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 132.5757}}}{space 1}{space 1}{ralign 9:{res:{sf:    21.66}}}{space 1}{space 1}{ralign 9:{res:{sf:    50.75}}}{space 1}{space 1}{ralign 9:{res:{sf:   111.65}}}{space 1}{space 1}{ralign 9:{res:{sf: 313.9908}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:prepaidcou~l}{space 1}{c |}{space 1}{ralign 9:{res:{sf:  4.14997}}}{space 1}{space 1}{ralign 9:{res:{sf:        2}}}{space 1}{space 1}{ralign 9:{res:{sf:        4}}}{space 1}{space 1}{ralign 9:{res:{sf:        6}}}{space 1}{space 1}{ralign 9:{res:{sf: 2.695313}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:preclosing~e}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 516.8389}}}{space 1}{space 1}{ralign 9:{res:{sf:    31.65}}}{space 1}{space 1}{ralign 9:{res:{sf:   127.33}}}{space 1}{space 1}{ralign 9:{res:{sf:   417.36}}}{space 1}{space 1}{ralign 9:{res:{sf: 1725.162}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}
{space 0}{space 0}{ralign 12:preage_of_~t}{space 1}{c |}{space 1}{ralign 9:{res:{sf: 45.11653}}}{space 1}{space 1}{ralign 9:{res:{sf:       19}}}{space 1}{space 1}{ralign 9:{res:{sf:       34}}}{space 1}{space 1}{ralign 9:{res:{sf:       55}}}{space 1}{space 1}{ralign 9:{res:{sf: 39.64127}}}{space 1}{space 1}{ralign 9:{res:{sf:    36094}}}{space 1}

{com}. 
. * Balance check
. foreach x in payment paymentcond invoices prepaidcounttotal preclosingbalance preage_of_account  {c -(}
{txt}  2{com}. reg `x' i.itt if itt!=. & t<=12, vce(cluster customer)
{txt}  3{com}. {c )-}

{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.22
                                                {txt}Prob > F          = {res}    0.8057
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res} 341.37

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}     payment{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} 1.720019{col 26}{space 2} 3.659843{col 37}{space 1}    0.47{col 46}{space 3}0.638{col 54}{space 4} -5.45402{col 67}{space 3} 8.894059
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-.6639158{col 26}{space 2} 3.552111{col 37}{space 1}   -0.19{col 46}{space 3}0.852{col 54}{space 4}-7.626779{col 67}{space 3} 6.298947
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 109.0334{col 26}{space 2} 2.464158{col 37}{space 1}   44.25{col 46}{space 3}0.000{col 54}{space 4} 104.2031{col 67}{space 3} 113.8636
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}    39,072
                                                {txt}F(2, 9143)        =  {res}     0.15
                                                {txt}Prob > F          = {res}    0.8600
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res} 515.51

{txt}{ralign 78:(Std. Err. adjusted for {res:9,144} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1} paymentcond{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} 3.716541{col 26}{space 2} 10.04271{col 37}{space 1}    0.37{col 46}{space 3}0.711{col 54}{space 4}-15.96941{col 67}{space 3} 23.40249
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-1.791949{col 26}{space 2} 9.719426{col 37}{space 1}   -0.18{col 46}{space 3}0.854{col 54}{space 4} -20.8442{col 67}{space 3}  17.2603
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 305.1962{col 26}{space 2} 6.771439{col 37}{space 1}   45.07{col 46}{space 3}0.000{col 54}{space 4} 291.9226{col 67}{space 3} 318.4697
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.15
                                                {txt}Prob > F          = {res}    0.8647
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res} 332.22

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}    invoices{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-2.211703{col 26}{space 2} 4.403438{col 37}{space 1}   -0.50{col 46}{space 3}0.615{col 54}{space 4}-10.84334{col 67}{space 3} 6.419935
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-1.856982{col 26}{space 2} 4.397147{col 37}{space 1}   -0.42{col 46}{space 3}0.673{col 54}{space 4}-10.47629{col 67}{space 3} 6.762324
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 134.4327{col 26}{space 2} 3.123057{col 37}{space 1}   43.05{col 46}{space 3}0.000{col 54}{space 4} 128.3109{col 67}{space 3} 140.5546
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.11
                                                {txt}Prob > F          = {res}    0.8962
                                                {txt}R-squared         = {res}    0.0000
                                                {txt}Root MSE          =    {res} 2.7129

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}prepaidcou~l{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} .0279957{col 26}{space 2} .0685738{col 37}{space 1}    0.41{col 46}{space 3}0.683{col 54}{space 4} -.106423{col 67}{space 3} .1624143
{txt}{space 10}2  {c |}{col 14}{res}{space 2} .0008241{col 26}{space 2} .0689653{col 37}{space 1}    0.01{col 46}{space 3}0.990{col 54}{space 4}-.1343621{col 67}{space 3} .1360102
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 4.149145{col 26}{space 2} .0491771{col 37}{space 1}   84.37{col 46}{space 3}0.000{col 54}{space 4} 4.052748{col 67}{space 3} 4.245543
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.83
                                                {txt}Prob > F          = {res}    0.4368
                                                {txt}R-squared         = {res}    0.0002
                                                {txt}Root MSE          =    {res} 1844.2

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}preclosing~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2}-60.01204{col 26}{space 2} 48.37632{col 37}{space 1}   -1.24{col 46}{space 3}0.215{col 54}{space 4}-154.8395{col 67}{space 3} 34.81543
{txt}{space 10}2  {c |}{col 14}{res}{space 2}-26.70449{col 26}{space 2} 50.30258{col 37}{space 1}   -0.53{col 46}{space 3}0.596{col 54}{space 4}-125.3078{col 67}{space 3} 71.89885
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 543.5434{col 26}{space 2} 39.48105{col 37}{space 1}   13.77{col 46}{space 3}0.000{col 54}{space 4} 466.1525{col 67}{space 3} 620.9343
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Linear regression                               Number of obs     = {res}   109,244
                                                {txt}F(2, 9875)        =  {res}     0.63
                                                {txt}Prob > F          = {res}    0.5306
                                                {txt}R-squared         = {res}    0.0001
                                                {txt}Root MSE          =    {res} 39.542

{txt}{ralign 78:(Std. Err. adjusted for {res:9,876} clusters in customer)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}preage_of_~t{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 9}itt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} 1.072228{col 26}{space 2} .9941911{col 37}{space 1}    1.08{col 46}{space 3}0.281{col 54}{space 4}-.8765891{col 67}{space 3} 3.021046
{txt}{space 10}2  {c |}{col 14}{res}{space 2} .8121932{col 26}{space 2} .9977833{col 37}{space 1}    0.81{col 46}{space 3}0.416{col 54}{space 4}-1.143666{col 67}{space 3} 2.768052
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 44.30434{col 26}{space 2} .7001831{col 37}{space 1}   63.28{col 46}{space 3}0.000{col 54}{space 4} 42.93183{col 67}{space 3} 45.67684
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}/Users/sebastiantonke/Desktop/Replication Package/Replication files experiment/output_logs/table A10.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}12 Jul 2023, 02:11:54
{txt}{.-}
{smcl}
{txt}{sf}{ul off}